package lzzy.net.mapper;

import lzzy.net.entity.Comment;
import org.apache.ibatis.annotations.*;

@Mapper
public interface CommentMapper {
    //根据ID查询评论
    @Select("SELECT * FROM t_comment WHERE id=#(id)")
    public Comment findById(Integer id);

    //插入新的评论
    @Insert("INSERT INTO t_comment(a_id,author, content) VALUES (#{aid},#{author},#{content})")
    public int insertComment(Comment comment);

    //更新评论
    @Update("UPDATE t_comment SET content=#{content} WHERE id=#{id}")
    public int updateComment(Comment comment);

    //删除评论
    @Delete("DELETE FROM t_comment WHERE id=#{id}")
    public  int deleteComment(Integer id);

}
